package com.wlgc.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.security.core.parameters.P;

@Mapper
public interface StudentMapper {
    //获取学生
    @Select("select sid from user_student_view where uid=#{uid}")
    public int getStudentSidByUid(@Param("uid") int uid);
    @Select("select sid from user_student_view where username=#{username}")
    public int getStudentSidByUsername(@Param("username") String username);
    @Select("select email from user_student_view where uid=#{uid}")
    public String getStudentEmailByUid(@Param("uid") int uid);
    @Select("select uid from user_student_view where uid=#{uid}")
    public String getStudentCnoByUid(@Param("uid") int uid);
    @Select("select name from user_student_view where uid=#{uid}")
    public String getStudentNameByUid(int uid);
}
